﻿19.4.2013 19:59:26
select * from [User] where nameLogin = @nameLogin and password = @password

19.4.2013 19:59:26
INSERT INTO Login ( idUser, 
login, 
idApplication) VALUES (  1, 
 to_date('19.4.2013 19:59:26', 'dd/mm/yyyy hh24:mi:ss'), 
 2) ; SELECT @@Identity

19.4.2013 19:59:26
DECLARE @idRole int = 1;--1 
select Modul.*, UserAdd.nameLogin as UserNameAdd, UserMod.nameLogin as UserNameMod  
from Modul 
left join [User] as UserAdd on Modul.userAdd = UserAdd.idUser 
left join [User] as UserMod on Modul.userMod = UserMod.idUser 
where 
idModul not in 
(
--Select vraci vsechny idModul, ktere maji byt neviditelne pro danou roli 
select Modul.idModul 
from Modul 
left join Rights on Modul.idModul = Rights.idModul 
where Rights.idRole = @idRole and visible = 0 
) 
order by idParent, orderModul

19.4.2013 19:59:28
UPDATE Login SET 
logout = to_date('19.4.2013 19:59:28', 'dd/mm/yyyy hh24:mi:ss')
 WHERE idLogin = 362 

